
CREATE TABLE daycare.NotificationSettingEmailList
  (
   NotificationSettingEmailListId INT NOT NULL
                                      PRIMARY KEY
                                      IDENTITY(1,1)
 , NotificationSettingId INT NOT NULL
 , AdultId INT NOT NULL
  )
ALTER TABLE daycare.NotificationSettingEmailList ADD CONSTRAINT FK_NotificationSettingEmailList_NotificationSettings FOREIGN KEY(NotificationSettingId) REFERENCES daycare.NotificationSettings(NotificationSettingId)
ALTER TABLE daycare.NotificationSettingEmailList ADD CONSTRAINT FK_NotificationSettingEmailList_Adults FOREIGN KEY(AdultId) REFERENCES daycare.Adults(AdultId)
GO